[dbo].[BAEEventGetRegistrationAnswersByQuestionId]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventGetRegistrationAnswersByQuestionId

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@questionId	int	4

SQL Script

CREATE PROCEDURE [dbo].[BAEEventGetRegistrationAnswersByQuestionId]
    @questionId as int
AS
    SELECT QuestionID, Question, Answer, q.EventCode, a.RegistrantID
    FROM EventRegistrationAnswer AS a, EventSetupQuestion AS q
    WHERE q.EventCode = a.EventCode AND
        q.EventSetupQuestionID = a.QuestionID AND
        q.EventSetupQuestionID = @questionId;

GO

Uses

[dbo].[EventRegistrationAnswer]
[dbo].[EventSetupQuestion]
dbo